﻿SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON

GO


CREATE PROCEDURE [dbo].[bhp_temp_AddBlogStructure]
AS
BEGIN

	DECLARE
		@BlogTabId				INT

	-- BLOG_POSTS.shortTitle
	UPDATE BLOG_POSTS SET shortTitle = ''
	ALTER TABLE BLOG_POSTS ALTER COLUMN shortTitle nvarchar(100) NOT NULL

	-- BLOG_POSTS.shortDescription
	UPDATE BLOG_POSTS SET shortDescription = ''
	ALTER TABLE BLOG_POSTS ALTER COLUMN shortDescription nvarchar(400) NOT NULL
END
GO

EXEC [bhp_temp_AddBlogStructure]
GO

DROP PROCEDURE [bhp_temp_AddBlogStructure]